mariadb log file location

[TOC]MARIADB Installing 11.6 mariadb installation 1. Download the installation package to the Unified directory/usr/local/src/[[email protected] ~]# cd /usr/local/src/[[email protected] src]#wget

Finally, I completed the login method when MariaDB and MySQL coexist. At that time, I knew that the installation was successful, that is, I could not log on to MariaDB. I would like to share my experiences with you. Finally, I completed the login

Mysqldump backup description mysqldump is a utility used by mysql to store databases. It mainly generates an SQL script, including the CREATETABLEINSERT command required to re-create a database from scratch, and is suitable for backing up databases

Method for separate login when MariaDB and MySQL coexist Finally, I completed the login method when MariaDB and MySQL coexist. At that time, I knew that the installation was successful, that is, I could not log on to MariaDB. I would like to share

Master and Slave server time to synchronize, the database version is best consistent, so as to avoid the function of processing, log read, log parsing and other anomalies. The following three master-slave replication settings are independent.

Use mysqldump to back up MariaDB Introduction to mysqldump backupMysqldump is a utility used by mysql to store databases. It mainly generates an SQL script, including the CREATE TABLE INSERT command required to re-CREATE a database from scratch. It

Use LVM to back up and restore the MariaDB Database Comparison with mysqldump to introduce LVM snapshot volumesMysqldump: Hot Backup cannot be performed, and the backup time is long when the database is large. The advantage is that the Backup

What is MMM? MMM (MySQL master replication Manager) is a set of scripting programs that support dual-master failover and dual-master daily management. MMM is developed using the Perl language, which is mainly used to monitor and manage

The logs in MYSQL/MARIADB are broadly divided into the following categories:Query LogGeneral Query log:Slow query log:error LogBinary logRelay LogTransaction logA brief introduction to these kinds of logs, logs for our analysis of MySQL service has

MySQL Multi-instanceMySQL multi-instance, simple to understand is on a server, the MySQL service to open a number of different ports (such as 3306, 3307,3308), running multiple service processes. These MySQL service processes use different sockets